--SELECT * FROM companyfliter
--DELETE FROM companyfliter
--INSERT INTO srv_lnk.nchr2008.dbo.companyfliter
SELECT top 5
Convert(int,right(id,7)) AS [ID],Convert(int,right(jobseekerid,7)) AS [UserID],Convert(int,right(companyid,7)) AS [CompanyID],Convert(int,right(jobseekerid,7)) AS [CreatedUserId],[datecreated] AS [CreatedDate],Convert(int,right(jobseekerid,7)) AS [UpdatedUserId],[LastUpdated] AS [UpdatedDate]FROM Forest.dbo.cat_shieldedcompany
SELECT TOP 5 * FROM Forest.dbo.cat_shieldedcompany
select top 5 * from srv_lnk.nchr2008.dbo.companyfliter
